Spreadsheets can be used for more than just creating tables and charts and
summarizing data. Instead of just storing, summarizing, and formatting data, a financial model is used for analysis. Spreadsheets are now commonly used for creating complex mathematical models. In this course, we will explain how to build financial models in Excel by provides instructions, not templates. We will learn to develop value-added skills in spreadsheet modeling of financial applications.
This is a course emphasizing on learning by doing. What you learn from this course will be very important for your career. The major software used in this course is Excel.
We are going to use Excel as a tool to solve financial problems. Financial issues to be covered are capital budgeting, financial statement analysis, portfolio analysis, capital structure, dividend policy, bond management, option pricing, and option trading strategy.
Excel functions and tools, such as Data Table, Goal seeker, Solver etc. will be used intensively. Programming a VBA macro is an important task in this course.
After finishing this course, you can put the following statement, “Excel Expert”, on your resume and get a good job.
Class Schedule Week Date Contents
1 2014/9/16 The time value of money
2 2014/9/23 Financial ratio analysis
3 2014/9/30 Capital budgeting
4 2014/10/7 Sensitivity analysis, Scenario analysis, Simulation
5 2014/10/14 Statistics analysis and matrix operation
6 2014/10/21 Two-asset portfolio analysis
7 2014/10/28 3-asset portfolio analysis : matrix and VBA
8 2014/11/4 Optimal Capital structure
9 2014/11/11 Midterm examination
10 2014/11/18 Dividends Policy and practice
11 2014/11/25 Interest rate models
12 2014/12/2 Bond pricing and risk management
13 2014/12/9 Option pricing: Black-Scholes model
14 2014/12/16 Option pricing: Binominal model
15 2014/12/23 Option trading strategy
16 2014/12/30 No class
17 2015/1/6 Pivot tables
18 2015/1/13 Final examination
* Students with disability should come to me for appropriate